COLLECTION and KEY

 

Description

This is used to run a SQL statement to return a collection of values paired with a key.  The first column returned contains the KEY value and the second column the associated value. Then the COLLECTIONVALUE type can be used to access the collection.

 

COLLECTION and KEY Element/Attribute Table

TYPE=COLLECTION  KEY=GUID

Element

Attribute

Attribute Value

Element Value

<MathVariable>

TYPE

COLLECTION

 SQL statement.

 

XML Example

<MathVariable VARIABLENAME="FundGUIDs" TYPE="COLLECTION" DATATYPE="MAP">SELECT AsFundField.TextValue, AsFund.FundGUID FROM AsFund WHERE AsFundField.FieldName = 'FundID' AND AsFundField.TextValue IN ('1600','1601','1602')</MathVariable>